前置条件
iPaaS集成DWS使用微应用方式集成，需要分别安装AFCenter,iPaaS微应用版，DWS微服务版。 集成必要的安装包如下：
EOS_Platform_8.3.3_Private_Medium_Application.tar.gz
Primeton_iPaaS_9.1.0_Portal_Server.tar
Primeton_iPaaS_9.1.0_Portal_UI.tar
Primeton_DWS_Server_7.1.0.tar.gz
Primeton_DWS_UI_7.1.0.tar.gz
pubresmng_component_v8.3.3.0.zip
根据实际可选的安装包如下：
Primeton_iPaaS_9.1.0_APIGateway_Server.tar
Primeton_iPaaS_9.1.0_ESB_Server.tar
Primeton_DI_7.1.0.tar.gz
apache-dolphinscheduler-7.1.0-bin.tar.gz
apache-seatunnel-7.1.0-bin.tar.gz
apache-zookeeper-3.8.0-bin.tar.gzAFCenter、iPaaS、DWS使用同一个数据库。
AFCenter安装完成后，不要立即启动，等iPaaS、DWS产品安装完成后并分别执行了对应的初始化脚本后在启动。
# 安装AFCenter
AFCenter安装参考： afcenter环境搭建 (opens new window) 。（注意：只安装AFCenter，不用安装其他组件，AFCenter安装完成后，不要立即启动。）
# 安装iPaaS910
iPaaS910 Portal微服务安装参考： 1.4.2.2-Linux环境解压安装 。（注意：iPaaS910微服务安装完成后，不要立即启动。）
根据实际需求选择安装APIGateWay Server和ESB Server。（APIGateWay Server安装参考： 1.6.2-Linux环境解压安装 ；
ESB Server安装参考： 1.5.4-Linux环境解压安装 ）。
# 安装DWS
DWS安装参考：DWS安装指南 (opens new window) 。（注意：DWS安装完成后，不要立即启动。）
# nginx配置
打开nginx.conf文件，检查并添加如下配置：
upstream afcapp {
server 192.168.2.150:28083;# 修改为AFCenter的后端ip和端口
}
upstream dwsapp {
server 192.168.2.150:28085;# 修改为DWS的后端ip和端口
}
upstream ipaasapp {
server 192.168.2.150:8080;# 修改为ipaas的后端ip和端口
}
server {
listen 80;
server_name localhost;
client_max_body_size 200m;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection "Upgrade";
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Real-Port $remote_port;
proxy_set_header REMOTE-HOST $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_send_timeout 600s;
proxy_read_timeout 600s;
proxy_connect_timeout 600s;
location /afc {
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Real-Port $remote_port;
proxy_set_header REMOTE-HOST $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_pass http://afcapp/;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection "Upgrade";
}
location /DWS {
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Real-Port $remote_port;
proxy_set_header REMOTE-HOST $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
charset utf-8;
proxy_pass http://dwsapp/;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection "Upgrade";
proxy_read_timeout 600s;
}
location /api/esb/ {
proxy_pass http://ipaasapp/api/esb/;
}
location /ESB/api/eos/loggers {
proxy_pass http://ipaasapp/api/eos/loggers;
}
location /api/lowcode/ {
proxy_pass http://ipaasapp/api/lowcode/;
}
location / {
root /opt/afcenter_ui/;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection "Upgrade";
index index.html index.htm;
}
}
保存nginx.conf的配置，启动nginx服务。
# 启动AFCenter、iPaaS、DWS服务
分别启动AFCenter、iPaaS和DWS服务。查看AFCenter、iPaaS和DWS的启动日志，检查启动日志是否有报错。
# 权限配置
浏览器访问http://nginx-ip:nginx-port/， 用admin账号登录。进入“组织中心->账号管理”页面，为manager用户添加角色。
# 调整菜单结构
权限配置完成后，按照如下配置步骤可以优化菜单结构，效果如下：
注意：菜单结构优化需要打AFCenter补丁，EOSPlatform8.3.3补丁列表 (opens new window)，请下载最新的补丁合集，按照操作说明为AFCenter打补丁。
1、执行如下脚本:
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN, APP_ID) VALUES ('esb-227', '服务集成', 'ipaas_portal', NULL, NULL, 10, '0', 0, NULL, 'root', 'sys_tenant', NULL, NULL, '1', '1', NULL, NULL, 'shouye', NULL, NULL, NULL, NULL);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN, APP_ID) VALUES ('esb-228', '数据集成', 'dws_portal', NULL, NULL, 15, '0', 0, NULL, 'root', 'sys_tenant', NULL, NULL, '1', '1', NULL, NULL, 'shouye', NULL, NULL, NULL, NULL);
-- INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN, APP_ID) VALUES ('esb-229', '文件集成', 'bft_portal', NULL, NULL, 20, '0', 0, NULL, 'root', 'sys_tenant', NULL, NULL, '1', '1', NULL, NULL, 'shouye', NULL, NULL, NULL, NULL);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN, APP_ID) VALUES ('esb-230', '管理平台', 'afc_portal', NULL, NULL, 12, '0', 0, NULL, 'root', 'sys_tenant', NULL, NULL, '1', '1', NULL, NULL, 'shouye', NULL, NULL, NULL, NULL);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN, APP_ID) VALUES ('120', '概要', 'tenant_dashboard', '505', NULL, 1, '1', 0, NULL, 'esb-230', 'sys_tenant', NULL, NULL, '1', '1', NULL, NULL, 'fuwuqizuyong', NULL, NULL, 'fullScreen', NULL);
UPDATE afc_menu SET NAME = '流程中心', CODE = 'process_center', RES_ID = NULL, DESCRIPTION = 'linear-gradient(135deg,#77abf4,#2f7deb)', SORT_NO = 4, IS_LEAF = '0', TREE_LEVEL = 0, SEQ = NULL, PARENT_ID = 'esb-230', TENANT_ID = 'sys_tenant', CREATE_TIME = NULL, UPDATE_TIME = NULL, CREATE_USER = NULL, UPDATE_USER = NULL, IS_FIXED = NULL, OPEN_TYPE = NULL, MENU_ICON = 'falvsusong', MENU_TYPE = NULL, BUSINESS_OBJ_ID = NULL, IS_NEW_WINDOW_OPEN = NULL, APP_ID = NULL WHERE CODE = 'process_center';
UPDATE afc_menu SET NAME = '应用中心', CODE = 'app_center', RES_ID = NULL, DESCRIPTION = 'linear-gradient(135deg,#7ed49a,#46c26f)', SORT_NO = 3, IS_LEAF = '0', TREE_LEVEL = 0, SEQ = NULL, PARENT_ID = 'esb-230', TENANT_ID = 'sys_tenant', CREATE_TIME = NULL, UPDATE_TIME = NULL, CREATE_USER = NULL, UPDATE_USER = NULL, IS_FIXED = NULL, OPEN_TYPE = NULL, MENU_ICON = 'shuju_3', MENU_TYPE = 'pc', BUSINESS_OBJ_ID = NULL, IS_NEW_WINDOW_OPEN = NULL, APP_ID = NULL WHERE CODE = 'app_center';
UPDATE afc_menu SET NAME = '后台管理', CODE = 'background_manage', RES_ID = NULL, DESCRIPTION = NULL, SORT_NO = 7, IS_LEAF = '0', TREE_LEVEL = 0, SEQ = NULL, PARENT_ID = 'esb-230', TENANT_ID = 'sys_tenant', CREATE_TIME = NULL, UPDATE_TIME = NULL, CREATE_USER = NULL, UPDATE_USER = NULL, IS_FIXED = NULL, OPEN_TYPE = NULL, MENU_ICON = 'shezhi_4', MENU_TYPE = 'pc', BUSINESS_OBJ_ID = NULL, IS_NEW_WINDOW_OPEN = NULL, APP_ID = NULL WHERE CODE = 'background_manage';
UPDATE afc_menu SET NAME = '任务中心', CODE = 'taskcenter', RES_ID = NULL, DESCRIPTION = NULL, SORT_NO = 3, IS_LEAF = '0', TREE_LEVEL = 0, SEQ = NULL, PARENT_ID = 'esb-230', TENANT_ID = 'sys_tenant', CREATE_TIME = NULL, UPDATE_TIME = NULL, CREATE_USER = NULL, UPDATE_USER = NULL, IS_FIXED = NULL, OPEN_TYPE = NULL, MENU_ICON = 'woderenwu', MENU_TYPE = NULL, BUSINESS_OBJ_ID = NULL, IS_NEW_WINDOW_OPEN = NULL, APP_ID = NULL WHERE CODE = 'taskcenter';
UPDATE afc_menu SET NAME = '数据运维', CODE = 'data_ops', RES_ID = NULL, DESCRIPTION = NULL, SORT_NO = 10, IS_LEAF = '0', TREE_LEVEL = 0, SEQ = NULL, PARENT_ID = 'esb-228', TENANT_ID = 'sys_tenant', CREATE_TIME = NULL, UPDATE_TIME = NULL, CREATE_USER = NULL, UPDATE_USER = NULL, IS_FIXED = NULL, OPEN_TYPE = NULL, MENU_ICON = 'tuandui3', MENU_TYPE = NULL, BUSINESS_OBJ_ID = NULL, IS_NEW_WINDOW_OPEN = NULL, APP_ID = NULL WHERE CODE = 'data_ops';
UPDATE afc_menu SET NAME = '数据开发', CODE = 'prjDevMenu', RES_ID = NULL, DESCRIPTION = NULL, SORT_NO = 9, IS_LEAF = '0', TREE_LEVEL = 0, SEQ = NULL, PARENT_ID = 'esb-228', TENANT_ID = 'sys_tenant', CREATE_TIME = NULL, UPDATE_TIME = NULL, CREATE_USER = NULL, UPDATE_USER = NULL, IS_FIXED = NULL, OPEN_TYPE = NULL, MENU_ICON = 'tuandui3', MENU_TYPE = NULL, BUSINESS_OBJ_ID = NULL, IS_NEW_WINDOW_OPEN = NULL, APP_ID = NULL WHERE CODE = 'prjDevMenu';
UPDATE afc_menu SET NAME = '公共资源', CODE = 'public_resource_manager', RES_ID = NULL, DESCRIPTION = NULL, SORT_NO = 4, IS_LEAF = '0', TREE_LEVEL = 0, SEQ = NULL, PARENT_ID = 'esb-228', TENANT_ID = 'sys_tenant', CREATE_TIME = NULL, UPDATE_TIME = NULL, CREATE_USER = NULL, UPDATE_USER = NULL, IS_FIXED = NULL, OPEN_TYPE = NULL, MENU_ICON = 'tuandui3', MENU_TYPE = NULL, BUSINESS_OBJ_ID = NULL, IS_NEW_WINDOW_OPEN = NULL, APP_ID = NULL WHERE CODE = 'public_resource_manager';
UPDATE afc_menu SET NAME = '概要', CODE = 'tenant_dashboard', RES_ID = '505', DESCRIPTION = NULL, SORT_NO = 1, IS_LEAF = '1', TREE_LEVEL = 0, SEQ = NULL, PARENT_ID = 'esb-230', TENANT_ID = 'sys_tenant', CREATE_TIME = NULL, UPDATE_TIME = NULL, CREATE_USER = '1', UPDATE_USER = '1', IS_FIXED = NULL, OPEN_TYPE = NULL, MENU_ICON = 'fuwuqizuyong', MENU_TYPE = NULL, BUSINESS_OBJ_ID = NULL, IS_NEW_WINDOW_OPEN = 'fullScreen', APP_ID = NULL WHERE CODE = 'tenant_dashboard';
UPDATE afc_menu SET NAME = '开发中心', CODE = 'dev_center', RES_ID = '175', DESCRIPTION = 'linear-gradient(135deg,#a782f0,#7e47eb)', SORT_NO = 5, IS_LEAF = '0', TREE_LEVEL = 0, SEQ = NULL, PARENT_ID = 'esb-230', TENANT_ID = 'sys_tenant', CREATE_TIME = NULL, UPDATE_TIME = NULL, CREATE_USER = NULL, UPDATE_USER = NULL, IS_FIXED = NULL, OPEN_TYPE = NULL, MENU_ICON = 'tianxie1', MENU_TYPE = NULL, BUSINESS_OBJ_ID = NULL, IS_NEW_WINDOW_OPEN = 'fullScreen', APP_ID = NULL WHERE CODE = 'dev_center';
UPDATE afc_menu SET NAME = '运维管理', CODE = 'operationsMag', RES_ID = '378', DESCRIPTION = NULL, SORT_NO = 6, IS_LEAF = '0', TREE_LEVEL = 0, SEQ = NULL, PARENT_ID = 'esb-230', TENANT_ID = 'sys_tenant', CREATE_TIME = NULL, UPDATE_TIME = NULL, CREATE_USER = NULL, UPDATE_USER = NULL, IS_FIXED = NULL, OPEN_TYPE = NULL, MENU_ICON = 'shezhi_3', MENU_TYPE = 'pc', BUSINESS_OBJ_ID = NULL, IS_NEW_WINDOW_OPEN = 'fullScreen', APP_ID = NULL WHERE CODE = 'operationsMag';
UPDATE afc_menu SET NAME = '工作台', CODE = 'workbench', RES_ID = '391', DESCRIPTION = 'linear-gradient(135deg,#f18585,#eb5050)', SORT_NO = 2, IS_LEAF = '1', TREE_LEVEL = 0, SEQ = NULL, PARENT_ID = 'esb-230', TENANT_ID = 'sys_tenant', CREATE_TIME = NULL, UPDATE_TIME = NULL, CREATE_USER = NULL, UPDATE_USER = '1', IS_FIXED = NULL, OPEN_TYPE = NULL, MENU_ICON = 'kapianxingshi', MENU_TYPE = NULL, BUSINESS_OBJ_ID = NULL, IS_NEW_WINDOW_OPEN = 'fullScreen', APP_ID = NULL WHERE CODE = 'workbench';
UPDATE afc_menu SET NAME = '组织中心', CODE = 'org_center', RES_ID = '505', DESCRIPTION = 'linear-gradient(135deg,#63d1e8,#00aed1)', SORT_NO = 2, IS_LEAF = '0', TREE_LEVEL = 0, SEQ = NULL, PARENT_ID = 'esb-230', TENANT_ID = 'sys_tenant', CREATE_TIME = NULL, UPDATE_TIME = NULL, CREATE_USER = NULL, UPDATE_USER = '1', IS_FIXED = NULL, OPEN_TYPE = NULL, MENU_ICON = 'fuwu', MENU_TYPE = NULL, BUSINESS_OBJ_ID = NULL, IS_NEW_WINDOW_OPEN = '', APP_ID = NULL WHERE CODE = 'org_center';
-- UPDATE afc_menu SET NAME = '文件集成', CODE = 'bft', RES_ID = NULL, DESCRIPTION = NULL, SORT_NO = 1, IS_LEAF = '0', TREE_LEVEL = 0, SEQ = NULL, PARENT_ID = 'esb-229', TENANT_ID = 'sys_tenant', CREATE_TIME = NULL, UPDATE_TIME = NULL, CREATE_USER = 'admin', UPDATE_USER = 'admin', IS_FIXED = NULL, OPEN_TYPE = NULL, MENU_ICON = 'fenlei_3', MENU_TYPE = NULL, BUSINESS_OBJ_ID = NULL, IS_NEW_WINDOW_OPEN = '', APP_ID = NULL WHERE CODE = 'bft';
UPDATE afc_menu SET NAME = 'API运维', CODE = 'DevOps', RES_ID = NULL, DESCRIPTION = NULL, SORT_NO = 15, IS_LEAF = '0', TREE_LEVEL = 0, SEQ = NULL, PARENT_ID = 'esb-227', TENANT_ID = 'sys_tenant', CREATE_TIME = NULL, UPDATE_TIME = NULL, CREATE_USER = NULL, UPDATE_USER = NULL, IS_FIXED = NULL, OPEN_TYPE = NULL, MENU_ICON = 'fenlei_6', MENU_TYPE = NULL, BUSINESS_OBJ_ID = NULL, IS_NEW_WINDOW_OPEN = '', APP_ID = NULL WHERE CODE = 'DevOps';
UPDATE afc_menu SET NAME = 'API管理', CODE = 'Manage', RES_ID = NULL, DESCRIPTION = NULL, SORT_NO = 11, IS_LEAF = '0', TREE_LEVEL = 0, SEQ = NULL, PARENT_ID = 'esb-227', TENANT_ID = 'sys_tenant', CREATE_TIME = NULL, UPDATE_TIME = NULL, CREATE_USER = NULL, UPDATE_USER = NULL, IS_FIXED = NULL, OPEN_TYPE = NULL, MENU_ICON = 'kapianxingshi', MENU_TYPE = NULL, BUSINESS_OBJ_ID = NULL, IS_NEW_WINDOW_OPEN = '', APP_ID = NULL WHERE CODE = 'Manage';
UPDATE afc_menu SET NAME = 'API开发', CODE = 'Developer', RES_ID = NULL, DESCRIPTION = NULL, SORT_NO = 12, IS_LEAF = '0', TREE_LEVEL = 0, SEQ = NULL, PARENT_ID = 'esb-227', TENANT_ID = 'sys_tenant', CREATE_TIME = NULL, UPDATE_TIME = NULL, CREATE_USER = NULL, UPDATE_USER = NULL, IS_FIXED = NULL, OPEN_TYPE = NULL, MENU_ICON = 'gift', MENU_TYPE = NULL, BUSINESS_OBJ_ID = NULL, IS_NEW_WINDOW_OPEN = '', APP_ID = NULL WHERE CODE = 'Developer';
UPDATE afc_menu SET NAME = '首页', CODE = 'homepage', RES_ID = 'esb-692', DESCRIPTION = NULL, SORT_NO = 10, IS_LEAF = '0', TREE_LEVEL = 0, SEQ = NULL, PARENT_ID = 'esb-227', TENANT_ID = 'sys_tenant', CREATE_TIME = NULL, UPDATE_TIME = NULL, CREATE_USER = '1', UPDATE_USER = '1', IS_FIXED = NULL, OPEN_TYPE = NULL, MENU_ICON = 'shouye', MENU_TYPE = NULL, BUSINESS_OBJ_ID = NULL, IS_NEW_WINDOW_OPEN = 'fullScreen', APP_ID = NULL WHERE CODE = 'homepage';
UPDATE afc_menu SET NAME = 'API市场', CODE = 'apiMarketplace', RES_ID = 'esb-693', DESCRIPTION = NULL, SORT_NO = 16, IS_LEAF = '0', TREE_LEVEL = 0, SEQ = NULL, PARENT_ID = 'esb-227', TENANT_ID = 'sys_tenant', CREATE_TIME = NULL, UPDATE_TIME = NULL, CREATE_USER = '1', UPDATE_USER = '1', IS_FIXED = NULL, OPEN_TYPE = NULL, MENU_ICON = 'kapianxingshi', MENU_TYPE = NULL, BUSINESS_OBJ_ID = NULL, IS_NEW_WINDOW_OPEN = 'fullScreen', APP_ID = NULL WHERE CODE = 'apiMarketplace';
2、打开{AFCenter-UI}/config/app-config.json文件，将isSettingMenu配置改为true，在settingMenuList添加如下配置（如果app-config.json中没有isSettingMenu和settingMenuList配置，请手动添加该配置）：
"isSettingMenu":true,
"settingMenuList":[
{
"code":"ipaas_portal",
"name":"服务集成"
},
{
"code":"dws_portal",
"name":"数据集成"
},
{
"code":"afc_portal",
"name":"管理平台"
}
],
"myTaskMenuPath":"/process_center/bfp_my_task",
"appMyTaskMenuPath":"/app/bfp_my_process/bfp_my_task_theme",
"titleLang":{
"en_US":"Primeton iPaaS"
}
3、配置完成后，清除浏览器缓存，重新登录。
# 常见问题
1.admin用户登录后页面报错
报错原因是连接BPS服务失败，iPaaS不需要配置BPS服务，在“管理平台->应用中心->权限管理->角色管理”，取消“租户管理员”角色的如下权限：
2.DWS刷新调度引擎报错
需要将afc_user表EMPLOYEE_ID和afc_employee表的ID字段修改为数字，请执行如下脚本：
UPDATE afc_user SET EMPLOYEE_ID = '100000' WHERE EMPLOYEE_ID = 'esb-2';
UPDATE afc_user SET EMPLOYEE_ID = '100001' WHERE EMPLOYEE_ID = 'esb-21';
UPDATE afc_user SET EMPLOYEE_ID = '100002' WHERE EMPLOYEE_ID = 'esb-22';
UPDATE afc_user SET EMPLOYEE_ID = '100003' WHERE EMPLOYEE_ID = 'esb-23';
UPDATE afc_user SET EMPLOYEE_ID = '100004' WHERE EMPLOYEE_ID = 'esb-3';
UPDATE afc_user SET EMPLOYEE_ID = '100005' WHERE EMPLOYEE_ID = 'esb-4';
UPDATE afc_user SET EMPLOYEE_ID = '100006' WHERE EMPLOYEE_ID = 'esb-5';
UPDATE afc_user SET EMPLOYEE_ID = '100007' WHERE EMPLOYEE_ID = 'esb-6';
UPDATE afc_user SET EMPLOYEE_ID = '100008' WHERE EMPLOYEE_ID = 'esb-7';
UPDATE afc_employee SET ID='100000' WHERE ID = 'esb-2';
UPDATE afc_employee SET ID='100001' WHERE ID = 'esb-21';
UPDATE afc_employee SET ID='100002' WHERE ID = 'esb-22';
UPDATE afc_employee SET ID='100003' WHERE ID = 'esb-23';
UPDATE afc_employee SET ID='100004' WHERE ID = 'esb-3';
UPDATE afc_employee SET ID='100005' WHERE ID = 'esb-4';
UPDATE afc_employee SET ID='100006' WHERE ID = 'esb-5';
UPDATE afc_employee SET ID='100007' WHERE ID = 'esb-6';
UPDATE afc_employee SET ID='100008' WHERE ID = 'esb-7';